Statistics for Maintenance Modelling: Continuous Lifetime Distributions 1

# Calculating the Gumbel Distribution Using Excel¤

No specialised functions are provided by Excel but it is straightforward to calculate the probability density, the reliability and the hazard functions using Excel's exponential function EXP.

For example, suppose cell A1 contains , cell A2 contains and t is in cell A3, then the probability density function is:

f(t) = EXP( (A3 - A2) / A1 ) * EXP( -EXP( (A3 - A2) / A1 )) / A1

Close